﻿






-- 考勤记录新增
CREATE procedure [dbo].[KqjlInfo_Add]
@jsdsblsh int = null,
@jsdm varchar(50)=null,
@sfzh varchar(18)=null,
@xm varchar(10),
@qybmm varchar(100)=null,
@gz varchar(100) = null,
@fbm varchar(100) = null,
@kh varchar(10),
@kbs varchar(20)=null,
@kqsj datetime,
@jczt bit=null,
@sfdj bit,
@kqlx varchar(50),
@yyxp varchar(100)=null,
@zpxp varchar(100)=null
as
insert into Kqjl_Info([jsdsblsh],[jsdm],[sfzh],[xm],[qybmm],[gz],[fbm],[kh],[kbs],[kqsj],[jczt],[sfdj],[kqlx],[yyxp],[zpxp],[sfff])
values(@jsdsblsh,@jsdm,@sfzh,@xm,@qybmm,@gz,@fbm,@kh,@kbs,@kqsj,@jczt,@sfdj,@kqlx,@yyxp,@zpxp,case @kh when '1234567890' then 1 else 0 end)